<form action="spiel_eintragen_v.php" method="post">
Name: <input type="text" size="17" name="nameVerein"><br><br>
Tore Heim: <input type="text" size="5" name="tHeim"><br><br>
Tore Gast: <input type="text" size="5" name="tGast"><br><br>



<?php

	include("joomlaInt.php");
	
	$liga = 1;
	
	$abfrage = "SELECT * FROM teams WHERE leagueID=$liga ORDER BY name"; 
	$ergebnis = mysql_query($abfrage);
	
	echo '<select name="homeTeam" Size="1">';
	
	while ($row = mysql_fetch_object($ergebnis))
		{
			echo '<Option Value="',$row->id,'">' ,$row->name, '</option>';
		}
		
	echo"</select><br><br>";
	

	$ergebnis = mysql_query($abfrage);
	
	echo '<select name="guestTeam" Size="1">';
	
	
	while ($row = mysql_fetch_object($ergebnis))
		{
			$t=$row->id;
			echo '<Option Value="',$t,'">' ,$row->name, '</option>';
		}
		
	echo"</select><br><br>";



?>



<input type="submit" value="OK">
</form>